Dataset info
| Number of variables | 40 |
|---|---|
| Number of observations | 1000 |
| Missing cells | 1000 (2.5%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 1.4 MiB |
| Average record size in memory | 1.5 KiB |
Variables types
| CAT | 24 |
|---|---|
| NUM | 14 |
| BOOL | 1 |
| UNSUPPORTED | 1 |
Reproduction info
| Date of analysis | 2020-03-04 10:45:36.723587 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
_c39 has 1000 (100.0%) missing values | Missing |
_c39 is an unsupported type, check if it needs cleaning or further analysis | Warning |
capital-gains has 508 (50.8%) zeros | Zeros |
capital-loss has 475 (47.5%) zeros | Zeros |
incident_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
incident_date has a high cardinality: 60 distinct values | Warning |
incident_hour_of_the_day has 52 (5.2%) zeros | Zeros |
incident_location has a high cardinality: 1000 distinct values | Warning |
injury_claim has 25 (2.5%) zeros | Zeros |
policy_bind_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
policy_bind_date has a high cardinality: 951 distinct values | Warning |
property_claim has 19 (1.9%) zeros | Zeros |
umbrella_limit has 798 (79.8%) zeros | Zeros |
months_as_customer is highly correlated with age | High Correlation |
age is highly correlated with months_as_customer | High Correlation |
vehicle_claim is highly correlated with total_claim_amount | High Correlation |
total_claim_amount is highly correlated with vehicle_claim | High Correlation |
auto_model is highly correlated with auto_make | High Correlation |
auto_make is highly correlated with auto_model | High Correlation |
| Distinct count | 46 |
|---|---|
| Unique (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.948 |
|---|---|
| Minimum | 19 |
| Maximum | 64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 32 |
| median | 38 |
| Q3 | 44 |
| 95-th percentile | 57 |
| Maximum | 64 |
| Range | 45 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 9.140286694 |
|---|---|
| Coefficient of variation (CV) | 0.2346792311 |
| Kurtosis | -0.260255015 |
| Mean | 38.948 |
| Median Absolute Deviation (MAD) | 7.367272 |
| Skewness | 0.4789880471 |
| Sum | 38948 |
| Variance | 83.54484084 |
| Value | Count | Frequency (%) | |
| 43 | 49 | 4.9% | |
| 39 | 48 | 4.8% | |
| 41 | 45 | 4.5% | |
| 34 | 44 | 4.4% | |
| 30 | 42 | 4.2% | |
| 31 | 42 | 4.2% | |
| 38 | 42 | 4.2% | |
| 37 | 41 | 4.1% | |
| 33 | 39 | 3.9% | |
| 32 | 38 | 3.8% | |
| Other values (36) | 570 | 57.0% |
| Value | Count | Frequency (%) | |
| 19 | 1 | 0.1% | |
| 20 | 1 | 0.1% | |
| 21 | 6 | 0.6% | |
| 22 | 1 | 0.1% | |
| 23 | 7 | 0.7% |
| Value | Count | Frequency (%) | |
| 64 | 2 | 0.2% | |
| 63 | 2 | 0.2% | |
| 62 | 4 | 0.4% | |
| 61 | 10 | 1.0% | |
| 60 | 9 | 0.9% |
authorities_contacted
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Police | |
|---|---|
| Fire | |
| Other | |
| Ambulance | |
| None |
| Value | Count | Frequency (%) | |
| Police | 292 | 29.2% | |
| Fire | 223 | 22.3% | |
| Other | 198 | 19.8% | |
| Ambulance | 196 | 19.6% | |
| None | 91 | 9.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 9 |
|---|---|
| Mean length | 5.762 |
| Min length | 4 |
| Distinct count | 14 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Suburu | 80 |
|---|---|
| Dodge | 80 |
| Saab | 80 |
| Nissan | 78 |
| Chevrolet | 76 |
| Other values (9) |
| Value | Count | Frequency (%) | |
| Suburu | 80 | 8.0% | |
| Dodge | 80 | 8.0% | |
| Saab | 80 | 8.0% | |
| Nissan | 78 | 7.8% | |
| Chevrolet | 76 | 7.6% | |
| Ford | 72 | 7.2% | |
| BMW | 72 | 7.2% | |
| Toyota | 70 | 7.0% | |
| Audi | 69 | 6.9% | |
| Accura | 68 | 6.8% | |
| Other values (4) | 255 | 25.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 5.703 |
| Min length | 3 |
| Distinct count | 39 |
|---|---|
| Unique (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| RAM | 43 |
|---|---|
| Wrangler | 42 |
| A3 | 37 |
| Neon | 37 |
| MDX | 36 |
| Other values (34) |
| Value | Count | Frequency (%) | |
| RAM | 43 | 4.3% | |
| Wrangler | 42 | 4.2% | |
| A3 | 37 | 3.7% | |
| Neon | 37 | 3.7% | |
| MDX | 36 | 3.6% | |
| Jetta | 35 | 3.5% | |
| Passat | 33 | 3.3% | |
| A5 | 32 | 3.2% | |
| Legacy | 32 | 3.2% | |
| Pathfinder | 31 | 3.1% | |
| Other values (29) | 642 | 64.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 14 |
|---|---|
| Mean length | 5.178 |
| Min length | 2 |
auto_year
Real number (ℝ≥0)
| Distinct count | 21 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2005.103 |
|---|---|
| Minimum | 1995 |
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1995 |
|---|---|
| 5-th percentile | 1995 |
| Q1 | 2000 |
| median | 2005 |
| Q3 | 2010 |
| 95-th percentile | 2014 |
| Maximum | 2015 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.015860835 |
|---|---|
| Coefficient of variation (CV) | 0.003000275215 |
| Kurtosis | -1.171867756 |
| Mean | 2005.103 |
| Median Absolute Deviation (MAD) | 5.179266 |
| Skewness | -0.04828880711 |
| Sum | 2005103 |
| Variance | 36.19058158 |
| Value | Count | Frequency (%) | |
| 1995 | 56 | 5.6% | |
| 1999 | 55 | 5.5% | |
| 2005 | 54 | 5.4% | |
| 2011 | 53 | 5.3% | |
| 2006 | 53 | 5.3% | |
| 2007 | 52 | 5.2% | |
| 2003 | 51 | 5.1% | |
| 2010 | 50 | 5.0% | |
| 2009 | 50 | 5.0% | |
| 2013 | 49 | 4.9% | |
| Other values (11) | 477 | 47.7% |
| Value | Count | Frequency (%) | |
| 1995 | 56 | 5.6% | |
| 1996 | 37 | 3.7% | |
| 1997 | 46 | 4.6% | |
| 1998 | 40 | 4.0% | |
| 1999 | 55 | 5.5% |
| Value | Count | Frequency (%) | |
| 2015 | 47 | 4.7% | |
| 2014 | 44 | 4.4% | |
| 2013 | 49 | 4.9% | |
| 2012 | 46 | 4.6% | |
| 2011 | 53 | 5.3% |
bodily_injuries
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 0 | |
|---|---|
| 2 | |
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 340 | 34.0% | |
| 2 | 332 | 33.2% | |
| 1 | 328 | 32.8% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 338 |
|---|---|
| Unique (%) | 33.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25126.1 |
|---|---|
| Minimum | 0 |
| Maximum | 100500 |
| Zeros | 508 |
| Zeros (%) | 50.8% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 51025 |
| 95-th percentile | 70615 |
| Maximum | 100500 |
| Range | 100500 |
| Interquartile range (IQR) | 51025 |
Descriptive statistics
| Standard deviation | 27872.18771 |
|---|---|
| Coefficient of variation (CV) | 1.109292238 |
| Kurtosis | -1.276703511 |
| Mean | 25126.1 |
| Median Absolute Deviation (MAD) | 25842.7704 |
| Skewness | 0.4788502296 |
| Sum | 25126100 |
| Variance | 776858847.6 |
| Value | Count | Frequency (%) | |
| 0 | 508 | 50.8% | |
| 46300 | 5 | 0.5% | |
| 68500 | 4 | 0.4% | |
| 51500 | 4 | 0.4% | |
| 48900 | 3 | 0.3% | |
| 51100 | 3 | 0.3% | |
| 52600 | 3 | 0.3% | |
| 47600 | 3 | 0.3% | |
| 51700 | 3 | 0.3% | |
| 63600 | 3 | 0.3% | |
| Other values (328) | 461 | 46.1% |
| Value | Count | Frequency (%) | |
| 0 | 508 | 50.8% | |
| 800 | 1 | 0.1% | |
| 10000 | 1 | 0.1% | |
| 11000 | 1 | 0.1% | |
| 12100 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 100500 | 1 | 0.1% | |
| 98800 | 1 | 0.1% | |
| 94800 | 1 | 0.1% | |
| 91900 | 1 | 0.1% | |
| 90700 | 1 | 0.1% |
| Distinct count | 354 |
|---|---|
| Unique (%) | 35.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -26793.7 |
|---|---|
| Minimum | -111100 |
| Maximum | 0 |
| Zeros | 475 |
| Zeros (%) | 47.5% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | -111100 |
|---|---|
| 5-th percentile | -72305 |
| Q1 | -51500 |
| median | -23250 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 111100 |
| Interquartile range (IQR) | 51500 |
Descriptive statistics
| Standard deviation | 28104.09669 |
|---|---|
| Coefficient of variation (CV) | -1.048906896 |
| Kurtosis | -1.3138745 |
| Mean | -26793.7 |
| Median Absolute Deviation (MAD) | 25976.2244 |
| Skewness | -0.391471943 |
| Sum | -26793700 |
| Variance | 789840250.6 |
| Value | Count | Frequency (%) | |
| 0 | 475 | 47.5% | |
| -53700 | 5 | 0.5% | |
| -50300 | 5 | 0.5% | |
| -31700 | 5 | 0.5% | |
| -49200 | 4 | 0.4% | |
| -61400 | 4 | 0.4% | |
| -53800 | 4 | 0.4% | |
| -51000 | 4 | 0.4% | |
| -31400 | 4 | 0.4% | |
| -45300 | 4 | 0.4% | |
| Other values (344) | 486 | 48.6% |
| Value | Count | Frequency (%) | |
| -111100 | 1 | 0.1% | |
| -93600 | 1 | 0.1% | |
| -91400 | 1 | 0.1% | |
| -91200 | 1 | 0.1% | |
| -90600 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 475 | 47.5% | |
| -5700 | 1 | 0.1% | |
| -6300 | 1 | 0.1% | |
| -8500 | 1 | 0.1% | |
| -10600 | 1 | 0.1% |
collision_type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Rear Collision | |
|---|---|
| Side Collision | |
| Front Collision | |
| ? |
| Value | Count | Frequency (%) | |
| Rear Collision | 292 | 29.2% | |
| Side Collision | 276 | 27.6% | |
| Front Collision | 254 | 25.4% | |
| ? | 178 | 17.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 15 |
|---|---|
| Mean length | 11.94 |
| Min length | 1 |
fraud_reported
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| N | |
|---|---|
| Y |
| Value | Count | Frequency (%) | |
| N | 753 | 75.3% | |
| Y | 247 | 24.7% |
incident_city
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Springfield | |
|---|---|
| Arlington | |
| Columbus | |
| Northbend | |
| Hillsdale | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| Springfield | 157 | 15.7% | |
| Arlington | 152 | 15.2% | |
| Columbus | 149 | 14.9% | |
| Northbend | 145 | 14.5% | |
| Hillsdale | 141 | 14.1% | |
| Riverwood | 134 | 13.4% | |
| Northbrook | 122 | 12.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 11 |
|---|---|
| Mean length | 9.287 |
| Min length | 8 |
| Distinct count | 60 |
|---|---|
| Unique (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 2015-02-02 | 28 |
|---|---|
| 2015-02-17 | 26 |
| 2015-01-07 | 25 |
| 2015-02-04 | 24 |
| 2015-01-24 | 24 |
| Other values (55) |
| Value | Count | Frequency (%) | |
| 2015-02-02 | 28 | 2.8% | |
| 2015-02-17 | 26 | 2.6% | |
| 2015-01-07 | 25 | 2.5% | |
| 2015-02-04 | 24 | 2.4% | |
| 2015-01-24 | 24 | 2.4% | |
| 2015-01-10 | 24 | 2.4% | |
| 2015-01-19 | 23 | 2.3% | |
| 2015-01-08 | 22 | 2.2% | |
| 2015-01-30 | 21 | 2.1% | |
| 2015-01-13 | 21 | 2.1% | |
| Other values (50) | 762 | 76.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 24 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.644 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 52 |
| Zeros (%) | 5.2% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 23 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 6.951372928 |
|---|---|
| Coefficient of variation (CV) | 0.5969918351 |
| Kurtosis | -1.192940152 |
| Mean | 11.644 |
| Median Absolute Deviation (MAD) | 6.032104 |
| Skewness | -0.03558446644 |
| Sum | 11644 |
| Variance | 48.32158559 |
| Value | Count | Frequency (%) | |
| 17 | 54 | 5.4% | |
| 3 | 53 | 5.3% | |
| 0 | 52 | 5.2% | |
| 23 | 51 | 5.1% | |
| 16 | 49 | 4.9% | |
| 4 | 46 | 4.6% | |
| 13 | 46 | 4.6% | |
| 10 | 46 | 4.6% | |
| 6 | 44 | 4.4% | |
| 9 | 43 | 4.3% | |
| Other values (14) | 516 | 51.6% |
| Value | Count | Frequency (%) | |
| 0 | 52 | 5.2% | |
| 1 | 29 | 2.9% | |
| 2 | 31 | 3.1% | |
| 3 | 53 | 5.3% | |
| 4 | 46 | 4.6% |
| Value | Count | Frequency (%) | |
| 23 | 51 | 5.1% | |
| 22 | 38 | 3.8% | |
| 21 | 42 | 4.2% | |
| 20 | 34 | 3.4% | |
| 19 | 40 | 4.0% |
| Distinct count | 1000 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 4492 Andromedia Ave | 1 |
|---|---|
| 9007 Francis Hwy | 1 |
| 1422 Flute Ave | 1 |
| 8639 5th Hwy | 1 |
| 4429 Washington St | 1 |
| Other values (995) |
| Value | Count | Frequency (%) | |
| 4492 Andromedia Ave | 1 | 0.1% | |
| 9007 Francis Hwy | 1 | 0.1% | |
| 1422 Flute Ave | 1 | 0.1% | |
| 8639 5th Hwy | 1 | 0.1% | |
| 4429 Washington St | 1 | 0.1% | |
| 4755 1st St | 1 | 0.1% | |
| 7928 Maple Ridge | 1 | 0.1% | |
| 2950 MLK Ave | 1 | 0.1% | |
| 4687 5th Drive | 1 | 0.1% | |
| 1919 4th Lane | 1 | 0.1% | |
| Other values (990) | 990 | 99.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 23 |
|---|---|
| Mean length | 14.749 |
| Min length | 11 |
incident_severity
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Minor Damage | |
|---|---|
| Total Loss | |
| Major Damage | |
| Trivial Damage |
| Value | Count | Frequency (%) | |
| Minor Damage | 354 | 35.4% | |
| Total Loss | 280 | 28.0% | |
| Major Damage | 276 | 27.6% | |
| Trivial Damage | 90 | 9.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 14 |
|---|---|
| Mean length | 11.62 |
| Min length | 10 |
incident_state
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| NY | |
|---|---|
| SC | |
| WV | |
| NC | |
| VA | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| NY | 262 | 26.2% | |
| SC | 248 | 24.8% | |
| WV | 217 | 21.7% | |
| NC | 110 | 11.0% | |
| VA | 110 | 11.0% | |
| PA | 30 | 3.0% | |
| OH | 23 | 2.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
incident_type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Multi-vehicle Collision | |
|---|---|
| Single Vehicle Collision | |
| Vehicle Theft | |
| Parked Car |
| Value | Count | Frequency (%) | |
| Multi-vehicle Collision | 419 | 41.9% | |
| Single Vehicle Collision | 403 | 40.3% | |
| Vehicle Theft | 94 | 9.4% | |
| Parked Car | 84 | 8.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 24 |
|---|---|
| Mean length | 21.371 |
| Min length | 10 |
| Distinct count | 638 |
|---|---|
| Unique (%) | 63.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7433.42 |
|---|---|
| Minimum | 0 |
| Maximum | 21450 |
| Zeros | 25 |
| Zeros (%) | 2.5% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 450 |
| Q1 | 4295 |
| median | 6775 |
| Q3 | 11305 |
| 95-th percentile | 15662 |
| Maximum | 21450 |
| Range | 21450 |
| Interquartile range (IQR) | 7010 |
Descriptive statistics
| Standard deviation | 4880.951853 |
|---|---|
| Coefficient of variation (CV) | 0.6566226385 |
| Kurtosis | -0.7630870611 |
| Mean | 7433.42 |
| Median Absolute Deviation (MAD) | 4008.72512 |
| Skewness | 0.2648108785 |
| Sum | 7433420 |
| Variance | 23823690.99 |
| Value | Count | Frequency (%) | |
| 0 | 25 | 2.5% | |
| 480 | 7 | 0.7% | |
| 640 | 7 | 0.7% | |
| 580 | 5 | 0.5% | |
| 6340 | 5 | 0.5% | |
| 660 | 5 | 0.5% | |
| 780 | 5 | 0.5% | |
| 13520 | 5 | 0.5% | |
| 860 | 5 | 0.5% | |
| 1180 | 5 | 0.5% | |
| Other values (628) | 926 | 92.6% |
| Value | Count | Frequency (%) | |
| 0 | 25 | 2.5% | |
| 10 | 1 | 0.1% | |
| 220 | 1 | 0.1% | |
| 250 | 1 | 0.1% | |
| 280 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 21450 | 1 | 0.1% | |
| 21330 | 1 | 0.1% | |
| 20700 | 1 | 0.1% | |
| 19020 | 1 | 0.1% | |
| 18520 | 1 | 0.1% |
insured_education_level
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| JD | |
|---|---|
| High School | |
| Associate | |
| MD | |
| Masters | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| JD | 161 | 16.1% | |
| High School | 160 | 16.0% | |
| Associate | 145 | 14.5% | |
| MD | 144 | 14.4% | |
| Masters | 143 | 14.3% | |
| PhD | 125 | 12.5% | |
| College | 122 | 12.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 5.905 |
| Min length | 2 |
insured_hobbies
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| reading | 64 |
|---|---|
| exercise | 57 |
| paintball | 57 |
| bungie-jumping | 56 |
| golf | 55 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| reading | 64 | 6.4% | |
| exercise | 57 | 5.7% | |
| paintball | 57 | 5.7% | |
| bungie-jumping | 56 | 5.6% | |
| golf | 55 | 5.5% | |
| camping | 55 | 5.5% | |
| movies | 55 | 5.5% | |
| kayaking | 54 | 5.4% | |
| yachting | 53 | 5.3% | |
| hiking | 52 | 5.2% | |
| Other values (10) | 442 | 44.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 14 |
|---|---|
| Mean length | 8.113 |
| Min length | 4 |
insured_occupation
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| machine-op-inspct | 93 |
|---|---|
| prof-specialty | 85 |
| tech-support | 78 |
| sales | 76 |
| exec-managerial | 76 |
| Other values (9) |
| Value | Count | Frequency (%) | |
| machine-op-inspct | 93 | 9.3% | |
| prof-specialty | 85 | 8.5% | |
| tech-support | 78 | 7.8% | |
| sales | 76 | 7.6% | |
| exec-managerial | 76 | 7.6% | |
| craft-repair | 74 | 7.4% | |
| transport-moving | 72 | 7.2% | |
| other-service | 71 | 7.1% | |
| priv-house-serv | 71 | 7.1% | |
| armed-forces | 69 | 6.9% | |
| Other values (4) | 235 | 23.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 17 |
|---|---|
| Mean length | 13.521 |
| Min length | 5 |
insured_relationship
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| own-child | |
|---|---|
| other-relative | |
| not-in-family | |
| husband | |
| wife |
| Value | Count | Frequency (%) | |
| own-child | 183 | 18.3% | |
| other-relative | 177 | 17.7% | |
| not-in-family | 174 | 17.4% | |
| husband | 170 | 17.0% | |
| wife | 155 | 15.5% | |
| unmarried | 141 | 14.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 14 |
|---|---|
| Mean length | 9.466 |
| Min length | 4 |
insured_sex
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| FEMALE | |
|---|---|
| MALE |
| Value | Count | Frequency (%) | |
| FEMALE | 537 | 53.7% | |
| MALE | 463 | 46.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.074 |
| Min length | 4 |
insured_zip
Real number (ℝ≥0)
| Distinct count | 995 |
|---|---|
| Unique (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 501214.488 |
|---|---|
| Minimum | 430104 |
| Maximum | 620962 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 430104 |
|---|---|
| 5-th percentile | 433273.75 |
| Q1 | 448404.5 |
| median | 466445.5 |
| Q3 | 603251 |
| 95-th percentile | 617463.35 |
| Maximum | 620962 |
| Range | 190858 |
| Interquartile range (IQR) | 154846.5 |
Descriptive statistics
| Standard deviation | 71701.61094 |
|---|---|
| Coefficient of variation (CV) | 0.1430557429 |
| Kurtosis | -1.190711054 |
| Mean | 501214.488 |
| Median Absolute Deviation (MAD) | 64266.73706 |
| Skewness | 0.8165539259 |
| Sum | 501214488 |
| Variance | 5141121012 |
| Value | Count | Frequency (%) | |
| 446895 | 2 | 0.2% | |
| 456602 | 2 | 0.2% | |
| 477695 | 2 | 0.2% | |
| 469429 | 2 | 0.2% | |
| 431202 | 2 | 0.2% | |
| 453277 | 1 | 0.1% | |
| 443625 | 1 | 0.1% | |
| 469653 | 1 | 0.1% | |
| 471704 | 1 | 0.1% | |
| 453274 | 1 | 0.1% | |
| Other values (985) | 985 | 98.5% |
| Value | Count | Frequency (%) | |
| 430104 | 1 | 0.1% | |
| 430141 | 1 | 0.1% | |
| 430232 | 1 | 0.1% | |
| 430380 | 1 | 0.1% | |
| 430567 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 620962 | 1 | 0.1% | |
| 620869 | 1 | 0.1% | |
| 620819 | 1 | 0.1% | |
| 620757 | 1 | 0.1% | |
| 620737 | 1 | 0.1% |
| Distinct count | 391 |
|---|---|
| Unique (%) | 39.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.954 |
|---|---|
| Minimum | 0 |
| Maximum | 479 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 28.9 |
| Q1 | 115.75 |
| median | 199.5 |
| Q3 | 276.25 |
| 95-th percentile | 429.05 |
| Maximum | 479 |
| Range | 479 |
| Interquartile range (IQR) | 160.5 |
Descriptive statistics
| Standard deviation | 115.1131744 |
|---|---|
| Coefficient of variation (CV) | 0.5644075352 |
| Kurtosis | -0.4854280674 |
| Mean | 203.954 |
| Median Absolute Deviation (MAD) | 94.449356 |
| Skewness | 0.3621768478 |
| Sum | 203954 |
| Variance | 13251.04293 |
| Value | Count | Frequency (%) | |
| 194 | 8 | 0.8% | |
| 285 | 7 | 0.7% | |
| 140 | 7 | 0.7% | |
| 230 | 7 | 0.7% | |
| 128 | 7 | 0.7% | |
| 254 | 7 | 0.7% | |
| 101 | 7 | 0.7% | |
| 210 | 7 | 0.7% | |
| 156 | 6 | 0.6% | |
| 239 | 6 | 0.6% | |
| Other values (381) | 931 | 93.1% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 1 | 3 | 0.3% | |
| 2 | 2 | 0.2% | |
| 3 | 2 | 0.2% | |
| 4 | 3 | 0.3% |
| Value | Count | Frequency (%) | |
| 479 | 2 | 0.2% | |
| 478 | 2 | 0.2% | |
| 476 | 1 | 0.1% | |
| 475 | 2 | 0.2% | |
| 473 | 1 | 0.1% |
number_of_vehicles_involved
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 1 | |
|---|---|
| 3 | |
| 4 | 31 |
| 2 | 30 |
| Value | Count | Frequency (%) | |
| 1 | 581 | 58.1% | |
| 3 | 358 | 35.8% | |
| 4 | 31 | 3.1% | |
| 2 | 30 | 3.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
police_report_available
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| ? | |
|---|---|
| NO | |
| YES |
| Value | Count | Frequency (%) | |
| ? | 343 | 34.3% | |
| NO | 343 | 34.3% | |
| YES | 314 | 31.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 1.971 |
| Min length | 1 |
policy_annual_premium
Real number (ℝ≥0)
| Distinct count | 991 |
|---|---|
| Unique (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1256.40615 |
|---|---|
| Minimum | 433.33 |
| Maximum | 2047.59 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 433.33 |
|---|---|
| 5-th percentile | 855.112 |
| Q1 | 1089.6075 |
| median | 1257.2 |
| Q3 | 1415.695 |
| 95-th percentile | 1653.4435 |
| Maximum | 2047.59 |
| Range | 1614.26 |
| Interquartile range (IQR) | 326.0875 |
Descriptive statistics
| Standard deviation | 244.167395 |
|---|---|
| Coefficient of variation (CV) | 0.1943379495 |
| Kurtosis | 0.07388944021 |
| Mean | 1256.40615 |
| Median Absolute Deviation (MAD) | 194.3547854 |
| Skewness | 0.004401994527 |
| Sum | 1256406.15 |
| Variance | 59617.71676 |
| Value | Count | Frequency (%) | |
| 1374.22 | 2 | 0.2% | |
| 1558.29 | 2 | 0.2% | |
| 1389.13 | 2 | 0.2% | |
| 1073.83 | 2 | 0.2% | |
| 1074.07 | 2 | 0.2% | |
| 1281.25 | 2 | 0.2% | |
| 1215.36 | 2 | 0.2% | |
| 1524.45 | 2 | 0.2% | |
| 1362.87 | 2 | 0.2% | |
| 1139 | 1 | 0.1% | |
| Other values (981) | 981 | 98.1% |
| Value | Count | Frequency (%) | |
| 433.33 | 1 | 0.1% | |
| 484.67 | 1 | 0.1% | |
| 538.17 | 1 | 0.1% | |
| 566.11 | 1 | 0.1% | |
| 617.11 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2047.59 | 1 | 0.1% | |
| 1969.63 | 1 | 0.1% | |
| 1935.85 | 1 | 0.1% | |
| 1927.87 | 1 | 0.1% | |
| 1922.84 | 1 | 0.1% |
| Distinct count | 951 |
|---|---|
| Unique (%) | 95.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 1992-08-05 | 3 |
|---|---|
| 2006-01-01 | 3 |
| 1992-04-28 | 3 |
| 1997-07-14 | 2 |
| 1992-01-05 | 2 |
| Other values (946) |
| Value | Count | Frequency (%) | |
| 1992-08-05 | 3 | 0.3% | |
| 2006-01-01 | 3 | 0.3% | |
| 1992-04-28 | 3 | 0.3% | |
| 1997-07-14 | 2 | 0.2% | |
| 1992-01-05 | 2 | 0.2% | |
| 2000-06-04 | 2 | 0.2% | |
| 1998-11-11 | 2 | 0.2% | |
| 1997-11-07 | 2 | 0.2% | |
| 1997-11-15 | 2 | 0.2% | |
| 2001-09-25 | 2 | 0.2% | |
| Other values (941) | 977 | 97.7% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
policy_csl
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 250/500 | |
|---|---|
| 100/300 | |
| 500/1000 |
| Value | Count | Frequency (%) | |
| 250/500 | 351 | 35.1% | |
| 100/300 | 349 | 34.9% | |
| 500/1000 | 300 | 30.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 8 |
|---|---|
| Mean length | 7.3 |
| Min length | 7 |
policy_deductable
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 1000 | |
|---|---|
| 500 | |
| 2000 |
| Value | Count | Frequency (%) | |
| 1000 | 351 | 35.1% | |
| 500 | 342 | 34.2% | |
| 2000 | 307 | 30.7% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.658 |
| Min length | 3 |
| Distinct count | 1000 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 546238.648 |
|---|---|
| Minimum | 100804 |
| Maximum | 999435 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 100804 |
|---|---|
| 5-th percentile | 143969.6 |
| Q1 | 335980.25 |
| median | 533135 |
| Q3 | 759099.75 |
| 95-th percentile | 954279.1 |
| Maximum | 999435 |
| Range | 898631 |
| Interquartile range (IQR) | 423119.5 |
Descriptive statistics
| Standard deviation | 257063.0053 |
|---|---|
| Coefficient of variation (CV) | 0.4706056706 |
| Kurtosis | -1.132637689 |
| Mean | 546238.648 |
| Median Absolute Deviation (MAD) | 220126.3448 |
| Skewness | 0.03899064218 |
| Sum | 546238648 |
| Variance | 6.608138868e+10 |
| Value | Count | Frequency (%) | |
| 116735 | 1 | 0.1% | |
| 107181 | 1 | 0.1% | |
| 430794 | 1 | 0.1% | |
| 115399 | 1 | 0.1% | |
| 328387 | 1 | 0.1% | |
| 824116 | 1 | 0.1% | |
| 492224 | 1 | 0.1% | |
| 663190 | 1 | 0.1% | |
| 936638 | 1 | 0.1% | |
| 193213 | 1 | 0.1% | |
| Other values (990) | 990 | 99.0% |
| Value | Count | Frequency (%) | |
| 100804 | 1 | 0.1% | |
| 101421 | 1 | 0.1% | |
| 104594 | 1 | 0.1% | |
| 106186 | 1 | 0.1% | |
| 106873 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 999435 | 1 | 0.1% | |
| 998865 | 1 | 0.1% | |
| 998192 | 1 | 0.1% | |
| 996850 | 1 | 0.1% | |
| 996253 | 1 | 0.1% |
policy_state
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| OH | |
|---|---|
| IL | |
| IN |
| Value | Count | Frequency (%) | |
| OH | 352 | 35.2% | |
| IL | 338 | 33.8% | |
| IN | 310 | 31.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Distinct count | 626 |
|---|---|
| Unique (%) | 62.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7399.57 |
|---|---|
| Minimum | 0 |
| Maximum | 23670 |
| Zeros | 19 |
| Zeros (%) | 1.9% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 450 |
| Q1 | 4445 |
| median | 6750 |
| Q3 | 10885 |
| 95-th percentile | 15540 |
| Maximum | 23670 |
| Range | 23670 |
| Interquartile range (IQR) | 6440 |
Descriptive statistics
| Standard deviation | 4824.726179 |
|---|---|
| Coefficient of variation (CV) | 0.6520279122 |
| Kurtosis | -0.3763863117 |
| Mean | 7399.57 |
| Median Absolute Deviation (MAD) | 3879.07238 |
| Skewness | 0.3781687764 |
| Sum | 7399570 |
| Variance | 23277982.7 |
| Value | Count | Frequency (%) | |
| 0 | 19 | 1.9% | |
| 860 | 6 | 0.6% | |
| 660 | 5 | 0.5% | |
| 480 | 5 | 0.5% | |
| 10000 | 5 | 0.5% | |
| 650 | 5 | 0.5% | |
| 11080 | 5 | 0.5% | |
| 640 | 5 | 0.5% | |
| 680 | 4 | 0.4% | |
| 5720 | 4 | 0.4% | |
| Other values (616) | 937 | 93.7% |
| Value | Count | Frequency (%) | |
| 0 | 19 | 1.9% | |
| 20 | 1 | 0.1% | |
| 240 | 1 | 0.1% | |
| 250 | 1 | 0.1% | |
| 260 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 23670 | 1 | 0.1% | |
| 21810 | 1 | 0.1% | |
| 21630 | 1 | 0.1% | |
| 21580 | 1 | 0.1% | |
| 21240 | 1 | 0.1% |
property_damage
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| ? | |
|---|---|
| NO | |
| YES |
| Value | Count | Frequency (%) | |
| ? | 360 | 36.0% | |
| NO | 338 | 33.8% | |
| YES | 302 | 30.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 1.942 |
| Min length | 1 |
| Distinct count | 763 |
|---|---|
| Unique (%) | 76.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52761.94 |
|---|---|
| Minimum | 100 |
| Maximum | 114920 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 4320 |
| Q1 | 41812.5 |
| median | 58055 |
| Q3 | 70592.5 |
| 95-th percentile | 88413 |
| Maximum | 114920 |
| Range | 114820 |
| Interquartile range (IQR) | 28780 |
Descriptive statistics
| Standard deviation | 26401.53319 |
|---|---|
| Coefficient of variation (CV) | 0.5003897353 |
| Kurtosis | -0.4540814267 |
| Mean | 52761.94 |
| Median Absolute Deviation (MAD) | 20738.4732 |
| Skewness | -0.5945819885 |
| Sum | 52761940 |
| Variance | 697040954.8 |
| Value | Count | Frequency (%) | |
| 59400 | 5 | 0.5% | |
| 75400 | 4 | 0.4% | |
| 60600 | 4 | 0.4% | |
| 2640 | 4 | 0.4% | |
| 58500 | 4 | 0.4% | |
| 44200 | 4 | 0.4% | |
| 4320 | 4 | 0.4% | |
| 3190 | 4 | 0.4% | |
| 70290 | 4 | 0.4% | |
| 70400 | 4 | 0.4% | |
| Other values (753) | 959 | 95.9% |
| Value | Count | Frequency (%) | |
| 100 | 1 | 0.1% | |
| 1920 | 1 | 0.1% | |
| 2160 | 1 | 0.1% | |
| 2250 | 1 | 0.1% | |
| 2400 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 114920 | 1 | 0.1% | |
| 112320 | 1 | 0.1% | |
| 108480 | 1 | 0.1% | |
| 108030 | 1 | 0.1% | |
| 107900 | 1 | 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1101000 |
|---|---|
| Minimum | -1000000 |
| Maximum | 10000000 |
| Zeros | 798 |
| Zeros (%) | 79.8% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | -1000000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 6000000 |
| Maximum | 10000000 |
| Range | 11000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2297406.598 |
|---|---|
| Coefficient of variation (CV) | 2.086654494 |
| Kurtosis | 1.79207731 |
| Mean | 1101000 |
| Median Absolute Deviation (MAD) | 1761398 |
| Skewness | 1.806712199 |
| Sum | 1101000000 |
| Variance | 5.278077077e+12 |
| Value | Count | Frequency (%) | |
| 0 | 798 | 79.8% | |
| 6000000 | 57 | 5.7% | |
| 5000000 | 46 | 4.6% | |
| 4000000 | 39 | 3.9% | |
| 7000000 | 29 | 2.9% | |
| 3000000 | 12 | 1.2% | |
| 8000000 | 8 | 0.8% | |
| 9000000 | 5 | 0.5% | |
| 2000000 | 3 | 0.3% | |
| 10000000 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| -1000000 | 1 | 0.1% | |
| 0 | 798 | 79.8% | |
| 2000000 | 3 | 0.3% | |
| 3000000 | 12 | 1.2% | |
| 4000000 | 39 | 3.9% |
| Value | Count | Frequency (%) | |
| 10000000 | 2 | 0.2% | |
| 9000000 | 5 | 0.5% | |
| 8000000 | 8 | 0.8% | |
| 7000000 | 29 | 2.9% | |
| 6000000 | 57 | 5.7% |
| Distinct count | 726 |
|---|---|
| Unique (%) | 72.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37928.95 |
|---|---|
| Minimum | 70 |
| Maximum | 79560 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 3273.5 |
| Q1 | 30292.5 |
| median | 42100 |
| Q3 | 50822.5 |
| 95-th percentile | 63094.5 |
| Maximum | 79560 |
| Range | 79490 |
| Interquartile range (IQR) | 20530 |
Descriptive statistics
| Standard deviation | 18886.25289 |
|---|---|
| Coefficient of variation (CV) | 0.4979376675 |
| Kurtosis | -0.4465729231 |
| Mean | 37928.95 |
| Median Absolute Deviation (MAD) | 14924.5768 |
| Skewness | -0.6210979312 |
| Sum | 37928950 |
| Variance | 356690548.3 |
| Value | Count | Frequency (%) | |
| 5040 | 7 | 0.7% | |
| 3360 | 6 | 0.6% | |
| 3600 | 5 | 0.5% | |
| 44800 | 5 | 0.5% | |
| 33600 | 5 | 0.5% | |
| 4720 | 5 | 0.5% | |
| 52080 | 5 | 0.5% | |
| 42720 | 4 | 0.4% | |
| 46800 | 4 | 0.4% | |
| 41760 | 4 | 0.4% | |
| Other values (716) | 950 | 95.0% |
| Value | Count | Frequency (%) | |
| 70 | 1 | 0.1% | |
| 1440 | 2 | 0.2% | |
| 1680 | 2 | 0.2% | |
| 1750 | 1 | 0.1% | |
| 1760 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 79560 | 1 | 0.1% | |
| 77760 | 1 | 0.1% | |
| 77670 | 2 | 0.2% | |
| 76400 | 1 | 0.1% | |
| 76000 | 1 | 0.1% |
witnesses
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 1 | |
|---|---|
| 2 | |
| 0 | |
| 3 |
| Value | Count | Frequency (%) | |
| 1 | 258 | 25.8% | |
| 2 | 250 | 25.0% | |
| 0 | 249 | 24.9% | |
| 3 | 243 | 24.3% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
First rows
| _c39 | age | authorities_contacted | auto_make | auto_model | auto_year | bodily_injuries | capital-gains | capital-loss | collision_type | fraud_reported | incident_city | incident_date | incident_hour_of_the_day | incident_location | incident_severity | incident_state | incident_type | injury_claim | insured_education_level | insured_hobbies | insured_occupation | insured_relationship | insured_sex | insured_zip | months_as_customer | number_of_vehicles_involved | police_report_available | policy_annual_premium | policy_bind_date | policy_csl | policy_deductable | policy_number | policy_state | property_claim | property_damage | total_claim_amount | umbrella_limit | vehicle_claim | witnesses | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | 48 | Police | Saab | 92x | 2004 | 1 | 53300 | 0 | Side Collision | Y | Columbus | 2015-01-25 | 5 | 9935 4th Drive | Major Damage | SC | Single Vehicle Collision | 6510 | MD | sleeping | craft-repair | husband | MALE | 466132 | 328 | 1 | YES | 1406.91 | 2014-10-17 | 250/500 | 1000 | 521585 | OH | 13020 | YES | 71610 | 0 | 52080 | 2 |
| 1 | NaN | 42 | Police | Mercedes | E400 | 2007 | 0 | 0 | 0 | ? | Y | Riverwood | 2015-01-21 | 8 | 6608 MLK Hwy | Minor Damage | VA | Vehicle Theft | 780 | MD | reading | machine-op-inspct | other-relative | MALE | 468176 | 228 | 1 | ? | 1197.22 | 2006-06-27 | 250/500 | 2000 | 342868 | IN | 780 | ? | 5070 | 5000000 | 3510 | 0 |
| 2 | NaN | 29 | Police | Dodge | RAM | 2007 | 2 | 35100 | 0 | Rear Collision | N | Columbus | 2015-02-22 | 7 | 7121 Francis Lane | Minor Damage | NY | Multi-vehicle Collision | 7700 | PhD | board-games | sales | own-child | FEMALE | 430632 | 134 | 3 | NO | 1413.14 | 2000-09-06 | 100/300 | 2000 | 687698 | OH | 3850 | NO | 34650 | 5000000 | 23100 | 3 |
| 3 | NaN | 41 | Police | Chevrolet | Tahoe | 2014 | 1 | 48900 | -62400 | Front Collision | Y | Arlington | 2015-01-10 | 5 | 6956 Maple Drive | Major Damage | OH | Single Vehicle Collision | 6340 | PhD | board-games | armed-forces | unmarried | FEMALE | 608117 | 256 | 1 | NO | 1415.74 | 1990-05-25 | 250/500 | 2000 | 227811 | IL | 6340 | ? | 63400 | 6000000 | 50720 | 2 |
| 4 | NaN | 44 | None | Accura | RSX | 2009 | 0 | 66000 | -46000 | ? | N | Arlington | 2015-02-17 | 20 | 3041 3rd Ave | Minor Damage | NY | Vehicle Theft | 1300 | Associate | board-games | sales | unmarried | MALE | 610706 | 228 | 1 | NO | 1583.91 | 2014-06-06 | 500/1000 | 1000 | 367455 | IL | 650 | NO | 6500 | 6000000 | 4550 | 1 |
| 5 | NaN | 39 | Fire | Saab | 95 | 2003 | 0 | 0 | 0 | Rear Collision | Y | Arlington | 2015-01-02 | 19 | 8973 Washington St | Major Damage | SC | Multi-vehicle Collision | 6410 | PhD | bungie-jumping | tech-support | unmarried | FEMALE | 478456 | 256 | 3 | NO | 1351.10 | 2006-10-12 | 250/500 | 1000 | 104594 | OH | 6410 | NO | 64100 | 0 | 51280 | 2 |
| 6 | NaN | 34 | Police | Nissan | Pathfinder | 2012 | 0 | 0 | -77000 | Front Collision | N | Springfield | 2015-01-13 | 0 | 5846 Weaver Drive | Minor Damage | NY | Multi-vehicle Collision | 21450 | PhD | board-games | prof-specialty | husband | MALE | 441716 | 137 | 3 | ? | 1333.35 | 2000-06-04 | 250/500 | 1000 | 413978 | IN | 7150 | ? | 78650 | 0 | 50050 | 0 |
| 7 | NaN | 37 | Police | Audi | A5 | 2015 | 2 | 0 | 0 | Front Collision | N | Columbus | 2015-02-27 | 23 | 3525 3rd Hwy | Total Loss | VA | Multi-vehicle Collision | 9380 | Associate | base-jumping | tech-support | unmarried | MALE | 603195 | 165 | 3 | YES | 1137.03 | 1990-02-03 | 100/300 | 1000 | 429027 | IL | 9380 | ? | 51590 | 0 | 32830 | 2 |
| 8 | NaN | 33 | Police | Toyota | Camry | 2012 | 1 | 0 | 0 | Front Collision | N | Arlington | 2015-01-30 | 21 | 4872 Rock Ridge | Total Loss | WV | Single Vehicle Collision | 2770 | PhD | golf | other-service | own-child | FEMALE | 601734 | 27 | 1 | YES | 1442.99 | 1997-02-05 | 100/300 | 500 | 485665 | IL | 2770 | NO | 27700 | 0 | 22160 | 1 |
| 9 | NaN | 42 | Other | Saab | 92x | 1996 | 2 | 0 | -39300 | Rear Collision | N | Hillsdale | 2015-01-05 | 14 | 3066 Francis Ave | Total Loss | NC | Single Vehicle Collision | 4700 | PhD | camping | priv-house-serv | wife | MALE | 600983 | 212 | 1 | ? | 1315.68 | 2011-07-25 | 100/300 | 500 | 636550 | IL | 4700 | NO | 42300 | 0 | 32900 | 1 |
Last rows
| _c39 | age | authorities_contacted | auto_make | auto_model | auto_year | bodily_injuries | capital-gains | capital-loss | collision_type | fraud_reported | incident_city | incident_date | incident_hour_of_the_day | incident_location | incident_severity | incident_state | incident_type | injury_claim | insured_education_level | insured_hobbies | insured_occupation | insured_relationship | insured_sex | insured_zip | months_as_customer | number_of_vehicles_involved | police_report_available | policy_annual_premium | policy_bind_date | policy_csl | policy_deductable | policy_number | policy_state | property_claim | property_damage | total_claim_amount | umbrella_limit | vehicle_claim | witnesses | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990 | NaN | 43 | Fire | Jeep | Grand Cherokee | 2013 | 2 | 77500 | -32800 | Rear Collision | N | Northbrook | 2015-01-31 | 18 | 4755 1st St | Minor Damage | NY | Single Vehicle Collision | 3810 | MD | movies | prof-specialty | unmarried | FEMALE | 477644 | 286 | 1 | YES | 1564.43 | 1994-02-05 | 100/300 | 500 | 663190 | IL | 3810 | ? | 34290 | 3000000 | 26670 | 2 |
| 991 | NaN | 44 | Other | Accura | TL | 2002 | 0 | 59400 | -32200 | Rear Collision | N | Riverwood | 2015-02-06 | 21 | 5312 Francis Ridge | Total Loss | WV | Single Vehicle Collision | 0 | MD | basketball | other-service | other-relative | MALE | 433981 | 257 | 1 | NO | 1280.88 | 2006-07-12 | 100/300 | 1000 | 109392 | OH | 5220 | NO | 46980 | 0 | 41760 | 1 |
| 992 | NaN | 26 | Fire | Nissan | Pathfinder | 2010 | 1 | 50300 | 0 | Front Collision | N | Springfield | 2015-01-23 | 6 | 1705 Weaver St | Major Damage | OH | Multi-vehicle Collision | 3670 | MD | camping | exec-managerial | husband | MALE | 433696 | 94 | 3 | YES | 722.66 | 2007-10-24 | 100/300 | 500 | 215278 | IN | 7340 | YES | 36700 | 0 | 25690 | 2 |
| 993 | NaN | 28 | Other | Volkswagen | Passat | 2012 | 0 | 0 | -32100 | Side Collision | N | Hillsdale | 2015-02-17 | 20 | 1643 Washington Hwy | Total Loss | OH | Multi-vehicle Collision | 6020 | MD | camping | exec-managerial | husband | MALE | 443567 | 124 | 3 | ? | 1235.14 | 2001-12-08 | 250/500 | 1000 | 674570 | OH | 6020 | ? | 60200 | 0 | 48160 | 1 |
| 994 | NaN | 30 | None | Honda | Civic | 1996 | 1 | 0 | -82100 | ? | N | Northbend | 2015-01-22 | 6 | 6516 Solo Drive | Minor Damage | SC | Parked Car | 540 | High School | bungie-jumping | sales | own-child | MALE | 430665 | 141 | 1 | YES | 1347.04 | 2007-03-24 | 500/1000 | 1000 | 681486 | IN | 1080 | ? | 6480 | 0 | 4860 | 2 |
| 995 | NaN | 38 | Fire | Honda | Accord | 2006 | 0 | 0 | 0 | Front Collision | N | Northbrook | 2015-02-22 | 20 | 6045 Andromedia St | Minor Damage | NC | Single Vehicle Collision | 17440 | Masters | paintball | craft-repair | unmarried | FEMALE | 431289 | 3 | 1 | ? | 1310.80 | 1991-07-16 | 500/1000 | 1000 | 941851 | OH | 8720 | YES | 87200 | 0 | 61040 | 1 |
| 996 | NaN | 41 | Fire | Volkswagen | Passat | 2015 | 2 | 70900 | 0 | Rear Collision | N | Northbend | 2015-01-24 | 23 | 3092 Texas Drive | Major Damage | SC | Single Vehicle Collision | 18080 | PhD | sleeping | prof-specialty | wife | FEMALE | 608177 | 285 | 1 | ? | 1436.79 | 2014-01-05 | 100/300 | 1000 | 186934 | IL | 18080 | YES | 108480 | 0 | 72320 | 3 |
| 997 | NaN | 34 | Police | Suburu | Impreza | 1996 | 2 | 35100 | 0 | Side Collision | N | Arlington | 2015-01-23 | 4 | 7629 5th St | Minor Damage | NC | Multi-vehicle Collision | 7500 | Masters | bungie-jumping | armed-forces | other-relative | FEMALE | 442797 | 130 | 3 | YES | 1383.49 | 2003-02-17 | 250/500 | 500 | 918516 | OH | 7500 | ? | 67500 | 3000000 | 52500 | 3 |
| 998 | NaN | 62 | Other | Audi | A5 | 1998 | 0 | 0 | 0 | Rear Collision | N | Arlington | 2015-02-26 | 2 | 6128 Elm Lane | Major Damage | NY | Single Vehicle Collision | 5220 | Associate | base-jumping | handlers-cleaners | wife | MALE | 441714 | 458 | 1 | YES | 1356.92 | 2011-11-18 | 500/1000 | 2000 | 533940 | IL | 5220 | ? | 46980 | 5000000 | 36540 | 1 |
| 999 | NaN | 60 | Police | Mercedes | E400 | 2007 | 0 | 0 | 0 | ? | N | Columbus | 2015-02-26 | 6 | 1416 Cherokee Ridge | Minor Damage | WV | Parked Car | 460 | Associate | kayaking | sales | husband | FEMALE | 612260 | 456 | 1 | ? | 766.19 | 1996-11-11 | 250/500 | 1000 | 556080 | OH | 920 | ? | 5060 | 0 | 3680 | 3 |